Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	341
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	40.1 KiB
Average record size in memory	120.4 B

Variable types

Unsupported	1
Categorical	2
Numeric	12

Alerts

`Symbol` has constant value "RELIANCE"	Constant
`Series` has constant value "EQ"	Constant
`Prev Close` is highly correlated with `Open` and 5 other fields	High correlation
`Open` is highly correlated with `Prev Close` and 5 other fields	High correlation
`High` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Low` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Last` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Close` is highly correlated with `Prev Close` and 5 other fields	High correlation
`VWAP` is highly correlated with `Prev Close` and 5 other fields	High correlation
`Volume` is highly correlated with `Turnover` and 2 other fields	High correlation
`Turnover` is highly correlated with `Volume` and 2 other fields	High correlation
`Trades` is highly correlated with `Volume` and 2 other fields	High correlation
`Deliverable Volume` is highly correlated with `Volume` and 2 other fields	High correlation
`Series` is highly correlated with `Symbol`	High correlation
`Symbol` is highly correlated with `Series`	High correlation
`VWAP` has unique values	Unique
`Volume` has unique values	Unique
`Turnover` has unique values	Unique
`Trades` has unique values	Unique
`Deliverable Volume` has unique values	Unique
`Date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported

Reproduction

Analysis started	2022-09-11 04:24:12.961542
Analysis finished	2022-09-11 04:25:03.258495
Duration	50.3 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

Date
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	2.8 KiB

Symbol
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	2.8 KiB

RELIANCE	341

Length

Max length	8
Median length	8
Mean length	8
Min length	8

Characters and Unicode

Total characters	2728
Distinct characters	7
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RELIANCE
2nd row	RELIANCE
3rd row	RELIANCE
4th row	RELIANCE
5th row	RELIANCE

Common Values

Value	Count	Frequency (%)
RELIANCE	341	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
reliance	341	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	682	25.0%
R	341	12.5%
L	341	12.5%
I	341	12.5%
A	341	12.5%
N	341	12.5%
C	341	12.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2728	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	682	25.0%
R	341	12.5%
L	341	12.5%
I	341	12.5%
A	341	12.5%
N	341	12.5%
C	341	12.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2728	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	682	25.0%
R	341	12.5%
L	341	12.5%
I	341	12.5%
A	341	12.5%
N	341	12.5%
C	341	12.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2728	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	682	25.0%
R	341	12.5%
L	341	12.5%
I	341	12.5%
A	341	12.5%
N	341	12.5%
C	341	12.5%

Series
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	2.8 KiB

EQ	341

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	682
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	EQ
2nd row	EQ
3rd row	EQ
4th row	EQ
5th row	EQ

Common Values

Value	Count	Frequency (%)
EQ	341	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
eq	341	100.0%

Most occurring characters

Value	Count	Frequency (%)
E	341	50.0%
Q	341	50.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	682	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	341	50.0%
Q	341	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	682	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	341	50.0%
Q	341	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	682	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	341	50.0%
Q	341	50.0%

Prev Close
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	335
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2404.766862

Minimum	1913.15
Maximum	2819.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1913.15
5-th percentile	1997.05
Q1	2244.9
median	2423.9
Q3	2572.85
95-th percentile	2700.4
Maximum	2819.85
Range	906.7
Interquartile range (IQR)	327.95

Descriptive statistics

Standard deviation	213.8930387
Coefficient of variation (CV)	0.08894543669
Kurtosis	-0.5672917834
Mean	2404.766862
Median Absolute Deviation (MAD)	156.25
Skewness	-0.4665628634
Sum	820025.5
Variance	45750.232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2627.4	2	0.6%
2425.6	2	0.6%
2086	2	0.6%
2227.4	2	0.6%
2378.3	2	0.6%
2700.4	2	0.6%
1997.3	1	0.3%
2626.05	1	0.3%
2663.7	1	0.3%
2655.85	1	0.3%
Other values (325)	325	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1913.15	1	0.3%
1916.6	1	0.3%
1920.1	1	0.3%
1926.2	1	0.3%
1931	1	0.3%
1931.75	1	0.3%
1933.15	1	0.3%
1937.3	1	0.3%
1959.05	1	0.3%
1960.35	1	0.3%

Value	Count	Frequency (%)
2819.85	1	0.3%
2798.75	1	0.3%
2790.25	1	0.3%
2782.1	1	0.3%
2780.45	1	0.3%
2779.5	1	0.3%
2778.35	1	0.3%
2775.65	1	0.3%
2772.75	1	0.3%
2767.55	1	0.3%

Open
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	315
Distinct (%)	92.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2406.898094

Minimum	1915
Maximum	2856.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1915
5-th percentile	1997.9
Q1	2250
median	2430.95
Q3	2574.9
95-th percentile	2710
Maximum	2856.15
Range	941.15
Interquartile range (IQR)	324.9

Descriptive statistics

Standard deviation	212.9058893
Coefficient of variation (CV)	0.08845654489
Kurtosis	-0.5570421691
Mean	2406.898094
Median Absolute Deviation (MAD)	151.7
Skewness	-0.4628813499
Sum	820752.25
Variance	45328.91769
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2400	3	0.9%
2452	3	0.9%
2600	3	0.9%
2560	3	0.9%
2610	3	0.9%
2430	2	0.6%
2174	2	0.6%
2380	2	0.6%
2373	2	0.6%
2058	2	0.6%
Other values (305)	316	92.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1915	1	0.3%
1921.85	1	0.3%
1923.35	1	0.3%
1928.05	1	0.3%
1930.1	1	0.3%
1937.3	1	0.3%
1937.75	1	0.3%
1939	1	0.3%
1950	1	0.3%
1966	1	0.3%

Value	Count	Frequency (%)
2856.15	1	0.3%
2809.95	1	0.3%
2785	1	0.3%
2780	1	0.3%
2772.75	1	0.3%
2771.9	1	0.3%
2769.9	1	0.3%
2762	1	0.3%
2758.9	1	0.3%
2755.85	1	0.3%

High
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	328
Distinct (%)	96.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2433.616569

Minimum	1932.9
Maximum	2856.15
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1932.9
5-th percentile	2016.45
Q1	2275.85
median	2457
Q3	2598.75
95-th percentile	2742.75
Maximum	2856.15
Range	923.25
Interquartile range (IQR)	322.9

Descriptive statistics

Standard deviation	216.9498059
Coefficient of variation (CV)	0.08914707793
Kurtosis	-0.5298882719
Mean	2433.616569
Median Absolute Deviation (MAD)	149
Skewness	-0.4741761527
Sum	829863.25
Variance	47067.21829
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2425	2	0.6%
2235	2	0.6%
2500	2	0.6%
2610	2	0.6%
2638	2	0.6%
2570	2	0.6%
2606	2	0.6%
2405	2	0.6%
2442	2	0.6%
2598.75	2	0.6%
Other values (318)	321	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1932.9	1	0.3%
1935	1	0.3%
1938.5	1	0.3%
1938.55	1	0.3%
1942	1	0.3%
1946.8	1	0.3%
1955.65	1	0.3%
1963.45	1	0.3%
1967.8	1	0.3%
1979	1	0.3%

Value	Count	Frequency (%)
2856.15	1	0.3%
2851	1	0.3%
2828	1	0.3%
2817.35	1	0.3%
2814	1	0.3%
2805.5	1	0.3%
2803	1	0.3%
2802	1	0.3%
2795	1	0.3%
2791.1	1	0.3%

Low
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	323
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2380.575513

Minimum	1906
Maximum	2786.1
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1906
5-th percentile	1986
Q1	2234.15
median	2404
Q3	2547.35
95-th percentile	2669.3
Maximum	2786.1
Range	880.1
Interquartile range (IQR)	313.2

Descriptive statistics

Standard deviation	208.9268729
Coefficient of variation (CV)	0.08776317816
Kurtosis	-0.5785960503
Mean	2380.575513
Median Absolute Deviation (MAD)	152.1
Skewness	-0.4533509196
Sum	811776.25
Variance	43650.43821
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2360	3	0.9%
2570	3	0.9%
2495	3	0.9%
2370	3	0.9%
2404	3	0.9%
2412	2	0.6%
2461	2	0.6%
2081	2	0.6%
2501	2	0.6%
2305	2	0.6%
Other values (313)	316	92.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1906	1	0.3%
1906.6	1	0.3%
1907	1	0.3%
1908.05	1	0.3%
1910	1	0.3%
1911	1	0.3%
1920.95	1	0.3%
1926	1	0.3%
1930.4	1	0.3%
1943.1	1	0.3%

Value	Count	Frequency (%)
2786.1	1	0.3%
2777.3	1	0.3%
2758.05	1	0.3%
2755.05	1	0.3%
2752.05	1	0.3%
2751.8	1	0.3%
2744.2	1	0.3%
2742	1	0.3%
2732	1	0.3%
2716.3	1	0.3%

Last
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	323
Distinct (%)	94.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2405.912023

Minimum	1913.05
Maximum	2810
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1913.05
5-th percentile	1995.9
Q1	2245
median	2424
Q3	2572
95-th percentile	2703.5
Maximum	2810
Range	896.95
Interquartile range (IQR)	327

Descriptive statistics

Standard deviation	213.0669025
Coefficient of variation (CV)	0.08855972307
Kurtosis	-0.5486879634
Mean	2405.912023
Median Absolute Deviation (MAD)	151.3
Skewness	-0.472091457
Sum	820416
Variance	45397.50496
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2090	3	0.9%
2668	3	0.9%
2112	2	0.6%
2530	2	0.6%
2225	2	0.6%
2635	2	0.6%
2178	2	0.6%
2626	2	0.6%
2382	2	0.6%
2589	2	0.6%
Other values (313)	319	93.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1913.05	1	0.3%
1918	1	0.3%
1921.5	1	0.3%
1926.8	1	0.3%
1927.1	1	0.3%
1932	1	0.3%
1933.9	1	0.3%
1937	1	0.3%
1956	1	0.3%
1958.85	1	0.3%

Value	Count	Frequency (%)
2810	1	0.3%
2799.7	1	0.3%
2796.05	1	0.3%
2788.2	1	0.3%
2782	1	0.3%
2780.9	1	0.3%
2778	1	0.3%
2776	1	0.3%
2767.05	1	0.3%
2766.25	1	0.3%

Close
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	335
Distinct (%)	98.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2406.444282

Minimum	1913.15
Maximum	2819.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1913.15
5-th percentile	1997.05
Q1	2250
median	2424.4
Q3	2572.85
95-th percentile	2700.4
Maximum	2819.85
Range	906.7
Interquartile range (IQR)	322.85

Descriptive statistics

Standard deviation	212.9288842
Coefficient of variation (CV)	0.08848278177
Kurtosis	-0.5467666656
Mean	2406.444282
Median Absolute Deviation (MAD)	154.25
Skewness	-0.4746055498
Sum	820597.5
Variance	45338.70972
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2425.6	2	0.6%
2086	2	0.6%
2227.4	2	0.6%
2378.3	2	0.6%
2700.4	2	0.6%
2627.4	2	0.6%
2672.95	1	0.3%
2619.05	1	0.3%
2626.05	1	0.3%
2663.7	1	0.3%
Other values (325)	325	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1913.15	1	0.3%
1916.6	1	0.3%
1920.1	1	0.3%
1926.2	1	0.3%
1931	1	0.3%
1931.75	1	0.3%
1933.15	1	0.3%
1937.3	1	0.3%
1959.05	1	0.3%
1960.35	1	0.3%

Value	Count	Frequency (%)
2819.85	1	0.3%
2798.75	1	0.3%
2790.25	1	0.3%
2782.1	1	0.3%
2780.45	1	0.3%
2779.5	1	0.3%
2778.35	1	0.3%
2775.65	1	0.3%
2772.75	1	0.3%
2767.55	1	0.3%

VWAP
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	341
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2407.293959

Minimum	1915.34
Maximum	2823.91
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1915.34
5-th percentile	1999.87
Q1	2257.44
median	2429.46
Q3	2574.11
95-th percentile	2710.69
Maximum	2823.91
Range	908.57
Interquartile range (IQR)	316.67

Descriptive statistics

Standard deviation	212.6284907
Coefficient of variation (CV)	0.0883267662
Kurtosis	-0.5413777399
Mean	2407.293959
Median Absolute Deviation (MAD)	151.79
Skewness	-0.4650870878
Sum	820887.24
Variance	45210.87506
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2024.21	1	0.3%
2557.8	1	0.3%
2636.9	1	0.3%
2658.17	1	0.3%
2641.48	1	0.3%
2642	1	0.3%
2661.36	1	0.3%
2623	1	0.3%
2611.69	1	0.3%
2596.66	1	0.3%
Other values (331)	331	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1915.34	1	0.3%
1920.95	1	0.3%
1923.26	1	0.3%
1925.2	1	0.3%
1929.4	1	0.3%
1932.02	1	0.3%
1935.83	1	0.3%
1940.01	1	0.3%
1950.25	1	0.3%
1958.46	1	0.3%

Value	Count	Frequency (%)
2823.91	1	0.3%
2817.63	1	0.3%
2794.98	1	0.3%
2793.34	1	0.3%
2783.29	1	0.3%
2775.79	1	0.3%
2773.48	1	0.3%
2773.03	1	0.3%
2768.55	1	0.3%
2763.87	1	0.3%

Volume
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	341
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7056064.891

Minimum	787160
Maximum	42209687
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	787160
5-th percentile	3455942
Q1	4768334
median	6081627
Q3	7973235
95-th percentile	12223037
Maximum	42209687
Range	41422527
Interquartile range (IQR)	3204901

Descriptive statistics

Standard deviation	4343831.713
Coefficient of variation (CV)	0.6156167467
Kurtosis	25.1994233
Mean	7056064.891
Median Absolute Deviation (MAD)	1505516
Skewness	4.201837923
Sum	2406118128
Variance	1.886887395 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8035915	1	0.3%
6077153	1	0.3%
6068663	1	0.3%
3659307	1	0.3%
3656408	1	0.3%
6102744	1	0.3%
7297028	1	0.3%
4007695	1	0.3%
4564891	1	0.3%
6563676	1	0.3%
Other values (331)	331	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
787160	1	0.3%
1853948	1	0.3%
2216708	1	0.3%
2502073	1	0.3%
2868235	1	0.3%
2924370	1	0.3%
2941883	1	0.3%
3044037	1	0.3%
3049304	1	0.3%
3083747	1	0.3%

Value	Count	Frequency (%)
42209687	1	0.3%
37841671	1	0.3%
32591420	1	0.3%
27285782	1	0.3%
26060864	1	0.3%
25546334	1	0.3%
19568487	1	0.3%
19317335	1	0.3%
16098099	1	0.3%
15525644	1	0.3%

Turnover
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	341
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.693305829 × 10¹⁵

Minimum	1.965800892 × 10¹⁴
Maximum	9.211999493 × 10¹⁵
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	1.965800892 × 10¹⁴
5-th percentile	8.115922559 × 10¹⁴
Q1	1.142314756 × 10¹⁵
median	1.458916963 × 10¹⁵
Q3	1.942001903 × 10¹⁵
95-th percentile	3.004172516 × 10¹⁵
Maximum	9.211999493 × 10¹⁵
Range	9.015419404 × 10¹⁵
Interquartile range (IQR)	7.996871468 × 10¹⁴

Descriptive statistics

Standard deviation	1.021721954 × 10¹⁵
Coefficient of variation (CV)	0.6033889074
Kurtosis	23.4013569
Mean	1.693305829 × 10¹⁵
Median Absolute Deviation (MAD)	3.812314512 × 10¹⁴
Skewness	3.97562863
Sum	5.774172878 × 10¹⁷
Variance	1.043915752 × 10³⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.626633943 × 10¹⁵	1	0.3%
1.554411585 × 10¹⁵	1	0.3%
1.600246615 × 10¹⁵	1	0.3%
9.72705226 × 10¹⁴	1	0.3%
9.658325027 × 10¹⁴	1	0.3%
1.612346563 × 10¹⁵	1	0.3%
1.942001903 × 10¹⁵	1	0.3%
1.051219846 × 10¹⁵	1	0.3%
1.192209306 × 10¹⁵	1	0.3%
1.704360617 × 10¹⁵	1	0.3%
Other values (331)	331	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.965800892 × 10¹⁴	1	0.3%
4.38805404 × 10¹⁴	1	0.3%
5.722594257 × 10¹⁴	1	0.3%
5.98656851 × 10¹⁴	1	0.3%
6.500981051 × 10¹⁴	1	0.3%
6.524718783 × 10¹⁴	1	0.3%
6.808700909 × 10¹⁴	1	0.3%
7.02822628 × 10¹⁴	1	0.3%
7.179873286 × 10¹⁴	1	0.3%
7.285364915 × 10¹⁴	1	0.3%

Value	Count	Frequency (%)
9.211999493 × 10¹⁵	1	0.3%
9.179980463 × 10¹⁵	1	0.3%
8.599389887 × 10¹⁵	1	0.3%
5.878142158 × 10¹⁵	1	0.3%
5.387879159 × 10¹⁵	1	0.3%
5.380107704 × 10¹⁵	1	0.3%
4.799499831 × 10¹⁵	1	0.3%
4.659492983 × 10¹⁵	1	0.3%
3.879858013 × 10¹⁵	1	0.3%
3.796726594 × 10¹⁵	1	0.3%

Trades
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	341
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	240334.6979

Minimum	63285
Maximum	1165095
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	63285
5-th percentile	131393
Q1	177038
median	219641
Q3	274696
95-th percentile	408746
Maximum	1165095
Range	1101810
Interquartile range (IQR)	97658

Descriptive statistics

Standard deviation	104565.6109
Coefficient of variation (CV)	0.4350832892
Kurtosis	20.19525305
Mean	240334.6979
Median Absolute Deviation (MAD)	46248
Skewness	3.229551421
Sum	81954132
Variance	1.093396698 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
213153	1	0.3%
221309	1	0.3%
204933	1	0.3%
167593	1	0.3%
163060	1	0.3%
249443	1	0.3%
219316	1	0.3%
203830	1	0.3%
183261	1	0.3%
276908	1	0.3%
Other values (331)	331	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
63285	1	0.3%
89509	1	0.3%
105190	1	0.3%
105619	1	0.3%
106030	1	0.3%
107475	1	0.3%
114345	1	0.3%
116529	1	0.3%
117855	1	0.3%
118469	1	0.3%

Value	Count	Frequency (%)
1165095	1	0.3%
755278	1	0.3%
642384	1	0.3%
629847	1	0.3%
624166	1	0.3%
525122	1	0.3%
497536	1	0.3%
496545	1	0.3%
493459	1	0.3%
482175	1	0.3%

Deliverable Volume
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	341
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3494253.824

Minimum	402932
Maximum	19734107
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	402932
5-th percentile	1584484
Q1	2310132
median	3012536
Q3	4117945
95-th percentile	6735937
Maximum	19734107
Range	19331175
Interquartile range (IQR)	1807813

Descriptive statistics

Standard deviation	2018793.697
Coefficient of variation (CV)	0.5777467234
Kurtosis	19.85326346
Mean	3494253.824
Median Absolute Deviation (MAD)	880867
Skewness	3.416603651
Sum	1191540554
Variance	4.075527993 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2834103	1	0.3%
3208900	1	0.3%
3962890	1	0.3%
1859891	1	0.3%
1845831	1	0.3%
3893403	1	0.3%
4259734	1	0.3%
2280912	1	0.3%
2149565	1	0.3%
3821279	1	0.3%
Other values (331)	331	97.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
402932	1	0.3%
532328	1	0.3%
1054022	1	0.3%
1082865	1	0.3%
1089396	1	0.3%
1160672	1	0.3%
1216161	1	0.3%
1230092	1	0.3%
1312810	1	0.3%
1436439	1	0.3%

Value	Count	Frequency (%)
19734107	1	0.3%
16124097	1	0.3%
15742153	1	0.3%
9894247	1	0.3%
9460717	1	0.3%
9245255	1	0.3%
8925205	1	0.3%
8601779	1	0.3%
7857043	1	0.3%
7709766	1	0.3%

%Deliverble
Real number (ℝ_≥0)

Distinct	324
Distinct (%)	95.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.5008601173

Minimum	0.2611
Maximum	0.7185
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	2.8 KiB

Quantile statistics

Minimum	0.2611
5-th percentile	0.3484
Q1	0.4531
median	0.5119
Q3	0.5598
95-th percentile	0.6337
Maximum	0.7185
Range	0.4574
Interquartile range (IQR)	0.1067

Descriptive statistics

Standard deviation	0.08567782192
Coefficient of variation (CV)	0.1710613781
Kurtosis	-0.007676732985
Mean	0.5008601173
Median Absolute Deviation (MAD)	0.0543
Skewness	-0.4086686431
Sum	170.7933
Variance	0.007340689169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.4597	2	0.6%
0.5952	2	0.6%
0.4711	2	0.6%
0.5437	2	0.6%
0.4953	2	0.6%
0.5752	2	0.6%
0.4815	2	0.6%
0.5521	2	0.6%
0.5204	2	0.6%
0.5877	2	0.6%
Other values (314)	321	94.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.2611	1	0.3%
0.2629	1	0.3%
0.2815	1	0.3%
0.2833	1	0.3%
0.2871	1	0.3%
0.2876	1	0.3%
0.293	1	0.3%
0.2951	1	0.3%
0.3068	1	0.3%
0.3079	1	0.3%

Value	Count	Frequency (%)
0.7185	1	0.3%
0.6902	1	0.3%
0.6858	1	0.3%
0.6689	1	0.3%
0.6667	1	0.3%
0.659	1	0.3%
0.6535	1	0.3%
0.653	1	0.3%
0.649	1	0.3%
0.6453	1	0.3%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble
0	2021-04-29	RELIANCE	EQ	1997.30	2022.90	2044.50	2007.30	2020.00	2024.05	2024.21	8035915	1.626634e+15	213153	2834103	0.3527
1	2021-04-30	RELIANCE	EQ	2024.05	2008.50	2036.00	1987.55	1995.90	1994.50	2010.20	9150974	1.839532e+15	288687	3902504	0.4265
2	2021-05-03	RELIANCE	EQ	1994.50	1966.00	1979.00	1943.10	1956.00	1959.05	1958.46	10909942	2.136664e+15	343806	3800598	0.3484
3	2021-05-04	RELIANCE	EQ	1959.05	1950.00	1967.80	1911.00	1918.00	1916.60	1935.83	10083693	1.952033e+15	325798	4435071	0.4398
4	2021-05-05	RELIANCE	EQ	1916.60	1923.35	1938.50	1908.05	1921.50	1920.10	1923.26	5719649	1.100036e+15	190990	1762417	0.3081
5	2021-05-06	RELIANCE	EQ	1920.10	1921.85	1935.00	1906.60	1932.00	1931.00	1920.95	6749281	1.296502e+15	221666	2830835	0.4194
6	2021-05-07	RELIANCE	EQ	1931.00	1937.75	1955.65	1926.00	1926.80	1931.75	1940.01	5671163	1.100213e+15	188670	2418447	0.4264
7	2021-05-10	RELIANCE	EQ	1931.75	1939.00	1946.80	1920.95	1927.10	1926.20	1932.02	6433879	1.243036e+15	197986	2996697	0.4658
8	2021-05-11	RELIANCE	EQ	1926.20	1915.00	1938.55	1910.00	1933.90	1933.15	1929.40	6220217	1.200129e+15	175976	3035544	0.4880
9	2021-05-12	RELIANCE	EQ	1933.15	1930.10	1932.90	1907.00	1913.05	1913.15	1915.34	6081627	1.164838e+15	212378	2760797	0.4540

Last rows

	Date	Symbol	Series	Prev Close	Open	High	Low	Last	Close	VWAP	Volume	Turnover	Trades	Deliverable Volume	%Deliverble
331	2022-08-26	RELIANCE	EQ	2632.05	2633.00	2650.00	2607.00	2623.00	2618.00	2622.30	4957449	1.299993e+15	191312	2885652	0.5821
332	2022-08-29	RELIANCE	EQ	2618.00	2585.00	2655.00	2578.05	2600.00	2597.65	2614.34	9155684	2.393607e+15	326003	3737011	0.4082
333	2022-08-30	RELIANCE	EQ	2597.65	2614.00	2645.25	2576.60	2642.00	2637.95	2614.74	10678670	2.792198e+15	285656	5624355	0.5267
334	2022-09-01	RELIANCE	EQ	2637.95	2582.65	2604.95	2550.70	2564.00	2560.40	2580.13	9188434	2.370736e+15	346414	5658983	0.6159
335	2022-09-02	RELIANCE	EQ	2560.40	2560.40	2575.35	2525.70	2527.95	2530.50	2546.24	5999196	1.527538e+15	266158	3185305	0.5310
336	2022-09-05	RELIANCE	EQ	2530.50	2531.00	2581.50	2531.00	2567.15	2569.80	2563.92	5227785	1.340362e+15	189614	2658456	0.5085
337	2022-09-06	RELIANCE	EQ	2569.80	2573.00	2606.00	2572.00	2594.00	2596.85	2592.68	5030172	1.304165e+15	174426	2588620	0.5146
338	2022-09-07	RELIANCE	EQ	2596.85	2575.00	2594.90	2570.00	2580.50	2581.75	2580.95	3455942	8.919602e+14	117855	1724115	0.4989
339	2022-09-08	RELIANCE	EQ	2581.75	2588.25	2598.00	2571.00	2583.05	2585.40	2583.54	3256840	8.414188e+14	116529	1821103	0.5592
340	2022-09-09	RELIANCE	EQ	2585.40	2610.00	2610.00	2564.00	2568.90	2569.30	2577.69	3837302	9.891380e+14	185947	2149444	0.5601

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows